﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using MaxLeaf.Platform.Contract;
using MaxLeaf.Platform.DataContract;
using CommonsLib.DB;
using System.Transactions;
using System.Data.SqlClient;
using System.Data.Common;
using System.Diagnostics;
using CommonsLib.Settings;
using MaxLeaf.Platform.Functions;
namespace MaxLeaf.Platform.DALImplementation
{
    public class SCPmLogQryDAL :BaseDAL
    {
        public override string GetTableName(object model)
        {
            string strSql =string.Format( @"(select log.* 
                ,isnull(u.UserName,'') as UserName
            from SCPmLog log 
            left join {0}muser_main u on log.userid=u.userid
            ) a
            ",GetBaseDatabase());
            return strSql;
        }
    }
}
